Quiz: Hierarchies

Task Description:

Tasks to complete:

Task List:

Clear your existing worksheet or create a new worksheet (in the bottom left next to Sheet 1).

Drag Sales to the Rows and Order Date to the Columns.

Click on the plus (+) next to Year in the Columns.

Quiz 1 below.

Click on the plus (+) next to the Quarter in the Columns.

Remove the Quarter from the Columns, so only Year and Month remain.

Quiz 2 below.

Convert the Order Date to Continuous and replace in the Columns.

Click the plus until you are showing MONTH.

Notice the visual advantages of this plot even though it is essentially the same as the one you created above.

Select Category and Sub-Category.

Click the drop down for Category, and select Hierarchy -> Create Hierarchy.

Name the hierarchy. I named mine Categories.

Assure you are working with a blank sheet.

Move Profit to the Columns and your new hierarchy to the Rows.

Quiz 3 below.

Click the '+' next to Categories.

Quiz 4 below.

Task Feedback:

Nice Work! You are getting the hang of this!

Quiz 1

What can we tell from this plot?

In each year, there appears to be an increase in sales from one month to the next month.

In each year, there appears to be an increase in sales from one quarter to the next quarter.

In each quarter, there appears to be an increase in sales from one year to the next year.

SOLUTION:

In each year, there appears to be an increase in sales from one quarter to the next quarter.

Quiz 2

When comparing two months, between which two months do you find a fall in sales for all years? (Select all that apply)

April to May

July to August

June to July

August to September

January to February

Previous year December to next year January

SOLUTION:

June to July
January to February
Previous year December to next year January

Quiz 3 Below

Which Category had the largest profits?

Furniture

Office Supplies

Technology

We can't tell.

SOLUTION:

Technology

QUIZ QUESTION::

Quiz 4

Match the item to the statement that describes it.

ANSWER CHOICES:

Item	Description
Tables
Appliances
Copiers
Fasteners
Bookcases

SOLUTION:

Item	Description
Copiers
Appliances
Bookcases
Fasteners
Tables